Improving the Data Warehouse Architecture Using Design Patterns

Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related data warehouse architectures including structure-oriented layer architectures and enterprise-view data mart architecture were studied in the literature. Existing architectures have the layer and data mart components but do not make use of design patterns; thus, those approaches are inefficient and pose potential problems. This paper relays how to use design patterns to improve data warehouse architectures

A selected ion flow tube study of the reactions of gas-phase cations with PSCl3

A selected ion flow tube was used to investigate the positive ion chemistry of thiophosphoryl chloride, PSCl$_3$. Rate coefficients and ion product branching ratios have been determined at room temperature for reactions with nineteen cations ; H$_3$O$^+$, CF$_3^+$, CF$^+$, NO$^+$, NO$_2^+$, SF$_2^+$, SF$^+$, CF$_2^+$, O$_2^+$, H$_2$O$^+$, N$_2$O$^+$, O$^+$, CO$_2^+$, CO$^+$, N$^+$, N$_2^+$, Ar$^+$, F$^+$ and Ne$^+$ (in order of increasing recombination energy). Complementary data described in the previous paper have been obtained for this molecule via the observation of threshold photoelectron photoion coincidences. For ions whose recombination energies are in the range 10-22 eV, comparisons are made between the product ion branching rations of PSCl$_3$ from photoionisation and from ion-molecule reactions. In most instances, the data from the two experiments are well correlated, suggesting that long-range charge transfer is the dominant mechanism for these ion-molecule reactions ; the agreement is particularly good for the atomic ions Ar$^+$, F$^+$ and Ne$^+$. Some reactions (e.g. O$_2^+$ + PSCl$_3$), however, exhibit significant differences; short-range charge transfer must then be occurring following the formation of an ion-molecule complex. For ions whose recombination energies are less than 10 eV (i.e. H$_3$O$^+$, CF$_3^+$, CF$^+$ and NO$^+$), reactions can only occur via a chemical process in which bonds are broken and formed, because the recombination energy of the cation is less than the ionisation energy of PSCl$_3$

Comparison of 4- and 5-beam acoustic Doppler current profiler configurations for measurement of turbulent kinetic energy

Acoustic Doppler current profilers (ADCPs) are commonly used to assess mean currents and turbulence at energetic sites. Since 2014, five-beam ADCP configurations have become more common, but conventional analysis of turbulence properties is still based on the four-beam Janus configuration. We use measurements from a single site to investigate improved estimates of turbulent kinetic energy (TKE) that are made possible by the addition of a fifth vertical beam. We conclude that four-beam estimates of TKE are suitable in most cases, and exhibit lower variance than five-beam estimates, but are more prone to contamination by wave activity

Surface Analysis Insight Note: Observations relating to photoemission peak shapes, oxidation state, and chemistry of titanium oxide films

It is common practice to describe the coordination of metal atoms in a binding configuration with their nearest neighbors in terms of oxidation state, a measure by which the number of electrons redistributed between atoms forming chemical bonds. In XPS terms, change to an oxidation state is commonly inferred by correlating photoemission signal with binding energy. The assumption, when classifying photoemission signals into distinct spectral shapes, is that a distribution of intensities shifted to lower binding energy is evidence of a reduction in oxidation state. In this Insight note, we raise the prospect that changes in photoemission peak shape may occur without obvious changes, determined by XPS in stoichiometry for a material. It is well known that TiO2 measured by XPS yields reproducible Ti 2p photoemission peaks. However, on exposing TiO2 to ion beams, Ti 2p photoemission evolves to complex distributions in intensity, which are particularly difficult to analyze by traditional fitting of bell‐shaped curves to these data. For these reasons, in this Insight note, a thin film of TiO2 deposited on a silicon substrate is chosen for analysis by XPS and linear algebraic techniques. Alterations in spectral shapes created from modified TiO2, which might be interpreted as the change in oxidation state, are assessed in terms of relative proportions of titanium to oxygen. It is found through detailed analysis of spectra that quantification by XPS, using procedures routinely used in practice, is not in accord with the typical interpretations of photoemission shapes. The data processing methods used and results presented in this work are of particular relevance to elucidating fundamental phenomena governing the surface evolution of materials‐enabled energy processes where cyclic/non‐steady usage changes the nature of bonding, especially in the presence of contaminants